BEGIN TRANSACTION GO ALTER TABLE dbo.Accounts ADD ParentAcTitle varchar(50) NOT NULL CONSTRAINT DF_Accounts_ParentAcTitle DEFAULT 'XYZ', imgURL varchar(50) NOT NULL CONSTRAINT DF_Accounts_imgURL DEFAULT 'STF1', PKR numeric(18, 2) NOT NULL CONSTRAINT DF_Accounts_PKR DEFAULT 0 GO COMMIT